#pragma once

namespace SqlCmd
{
	char const* const CUSTOMER_TABLE = "t_customer";
	char const* const DEALING_TABLE = "t_dealing";
	char const* const POSITION_TABLE = "t_position";
	char const* const MARKET_TABLE = "t_market";

	char const* const CREATE_CUSTOMER_TABLE = "create table t_customer(name char(10) primary key, clientId_shfe char(10), clientId_dce char(10), clientId_czce char(10), clientId_cffex char(10), funds double)";
	char const* const CREATE_POSITION_TABLE = "create table t_position(name char(10), contract char(10), direction char(1), position_TT int, avg_price double,  position_TD int, position_YD int)";
	char const* const CREATE_DEALING_TABLE = "create table t_dealing(requestId int primary key, name char(10), businessId int, systemId char(20), contract char(10), direction char(1), operator char(1), price double, quantity int, \
									   status char(1), deal_quantity int, avg_price double, remain_quantity int)";
	char const* const CREATE_MARTE_TABLE = "";

	char const* const INSERT_CUSTOMER = "insert into t_customer (name,clientId_shfe,clientId_dce,clientId_czce,clientId_cffex,funds) values(?,?,?,?,?,?)";
	char const* const UPDATE_CUSTOMER = "update t_customer set clientId_shfe=?,clientId_dce=?,clientId_czce=?,clientId_cffex=?,funds=?where name=?";

	char const* const INSERT_DEALING = "";
	char const* const INSERT_POSITION = "";
}